package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_device_bind", simpleName = "", engine = MysqlDriver.InnoDB, comment = "绑定设备")
public class _DDL_CDeviceBind {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, comment = "id")
    private Long id;

    @_DDL_Unique(name = "UNI_C_DEVICE_BIND_SSN")
    @_DDL_Column(name = "ssn", type = SqlType.VARCHAR, size = 32, comment = "设备序列号")
    private String ssn;

    @_DDL_Column(name = "channel", type = SqlType.VARCHAR, size = 10, comment = "设备渠道")
    private String channel;

    @_DDL_Column(name = "ag_id", type = SqlType.INT_UNSIGNED, comment = "渠道商id")
    private Long agId;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "商户id")
    private java.math.BigInteger merId;

    @_DDL_Column(name = "type", type = SqlType.VARCHAR, size = 100, comment = "品牌+类型")
    private String type;

    @_DDL_Column(name = "sign_time", type = SqlType.TIMESTAMP, comment = "最后一次签到时间")
    private java.sql.Timestamp signTime;

    @_DDL_Column(name = "code", type = SqlType.INT_UNSIGNED, comment = "设备版本代码")
    private Long code;

    @_DDL_Column(name = "dev_key", type = SqlType.VARCHAR, size = 64, comment = "设备秘钥")
    private String devKey;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, comment = "状态")
    private Integer state;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

}
